Tabela LServiceMaterial

Definicja tabeli LServiceMaterial

Name

LServiceMaterial

Code

LServiceMaterial

Comment

 


Lista kolumn tabeli LServiceMaterial

Name

Code

ServID

ServID

MaterialID

MaterialID

TimeTemplateID

TimeTemplateID

FrequencyID

FrequencyID

TestTubeID

TestTubeID

DefaultValue

DefaultValue

LServiceMaterialID

LServiceMaterialID

DefaultTestTube

DefaultTestTube


Kolumna ServID tabeli LServiceMaterial

Definicja kolumny ServID tabeli LServiceMaterial

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna MaterialID tabeli LServiceMaterial

Definicja kolumny MaterialID tabeli LServiceMaterial

Name

MaterialID

Code

MaterialID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna TimeTemplateID tabeli LServiceMaterial

Definicja kolumny TimeTemplateID tabeli LServiceMaterial

Name

TimeTemplateID

Code

TimeTemplateID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FrequencyID tabeli LServiceMaterial

Definicja kolumny FrequencyID tabeli LServiceMaterial

Name

FrequencyID

Code

FrequencyID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna TestTubeID tabeli LServiceMaterial

Definicja kolumny TestTubeID tabeli LServiceMaterial

Name

TestTubeID

Code

TestTubeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DefaultValue tabeli LServiceMaterial

Definicja kolumny DefaultValue tabeli LServiceMaterial

Name

DefaultValue

Code

DefaultValue

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LServiceMaterialID tabeli LServiceMaterial

Definicja kolumny LServiceMaterialID tabeli LServiceMaterial

Name

LServiceMaterialID

Code

LServiceMaterialID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DefaultTestTube tabeli LServiceMaterial

Definicja kolumny DefaultTestTube tabeli LServiceMaterial

Name

DefaultTestTube

Code

DefaultTestTube

Data Type

NUMBER(1)

Mandatory

Yes

Comment

oznaczenie próbówki domyslnej dla uslugi z materialem


Lista kluczy tabeli LServiceMaterial

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LServiceMaterial

Definicja klucza Identifier_1 tabeli LServiceMaterial

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment